drop table jms_dm.dm_end_dispatch_cheat_swip_detail_dt;

CREATE EXTERNAL TABLE jms_dm.dm_end_dispatch_cheat_swip_detail_dt(
  waybill_no string COMMENT '运单号', 
  sign_time timestamp COMMENT '签收时间', 
  pick_network_code string COMMENT '寄件网点编码', 
  pick_network_name string COMMENT '寄件网点名称', 
  pick_agent_code string COMMENT '寄件代理区编码', 
  pick_agent_name string COMMENT '寄件代理区', 
  sign_network_code string COMMENT '签收网点code', 
  sign_network_name string COMMENT '签收网点名称', 
  sign_agent_code string COMMENT '签收代理区编码', 
  sign_agent_name string COMMENT '签收代理区', 
  dispatch_network_code string COMMENT '派件网点code', 
  dispatch_network_name string COMMENT '派件网点名称', 
  dispatch_agent_code string COMMENT '派件代理区code', 
  dispatch_agent_name string COMMENT '派件代理区', 
  receiver_name string COMMENT '收件人姓名', 
  receiver_mobile_phone string COMMENT '收件人手机号', 
  receiver_province string COMMENT '收件省份', 
  receiver_city string COMMENT '收件城市', 
  receiver_area string COMMENT '收件区域', 
  receiver_detailed_address string COMMENT '收件详细地址', 
  mobile_phone_bf_trd string COMMENT '手机人手机号前三位', 
  mobile_phone_lst_fth string COMMENT '手机人手机号后四位'
  ) COMMENT '异常件-派件刷单明细表'
PARTITIONED BY (dt string COMMENT '')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_end_dispatch_cheat_swip_detail_dt'
TBLPROPERTIES (
'discover.partitions' = 'false',
'parquet.column.index.access' = 'true'
);